Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_1523

R_1523

StockItem

DrugDetails

StockItemID

 

 

R_1531

R_1531

StockItemQuantity

LStockItemQuantity

Sto_StockItemQuantityID

 

 

R_1532

R_1532

StockItemQuantity

LStockItemQuantity

StockItemQuantityID

 

 

R_1930

R_1930

Stock

LOrgUnitStock

StockID

 

 

R_1941

R_1941

StockEntryDocumentType

StockEntryDocument

StockEntryDocumentTypeID

 

 

R_1942

R_1942

StockEntryDocument

StockEntryDocumentItem

StockEntryDocumentID

 

 

R_1943

R_1943

StockEntryDocumentType

StockEntryDocumentTypeText

StockEntryDocumentTypeID

 

 

R_1944

R_1944

ExternalOrgUnit

StockEntryDocument

ExternalOrgUnitID

 

 

R_1945

R_1945

StockEntryDocumentItem

StockItemQuantityIndex

StockEntryDocumentItemID

 

 

R_1946

R_1946

StockEntryDocumentItem

StockItemQuantity

StockEntryDocumentItemID

 

 

R_1988

R_1988

StockItemQuantity

LStockItemQuantityPatient

StockItemQuantityID

 

 

R_1989

R_1989

Patient

LStockItemQuantityPatient

PersonID

 

 

R_2010

R_2010

PerfResource

LPerfResourceStockItemQuantity

PerfResourceID

 

 

R_2011

R_2011

StockItemQuantity

LPerfResourceStockItemQuantity

StockItemQuantityID

 

 

R_2020

R_2020

Person

LUserStock

PersonID

 

 

R_2021

R_2021

Stock

LUserStock

StockID

 

 

R_2070

R_2070

VATRate

StockEntryDocumentItem

VatRateID

 

 

R_5070

R_5070

StockItem

LStockItemStock

StockItemID

 

 

R_5071

R_5071

Stock

LStockItemStock

StockID

 

 

R_5072

R_5072

LStockItemStockType

LStockItemStockTypeText

LStockItemStockTypeID

 

 

R_5073

R_5073

LStockItemStockType

LStockItemStock

LStockItemStockTypeID

 

 

R_6090

R_6090

PerfResource

LPSPRStockDocument

PerfResourceID

 

 

R_6091

R_6091

PerfService

LPSPRStockDocument

PerfServiceID

 

 

R_6092

R_6092

StockDocument

LPSPRStockDocument

StockDocumentID

 

 

R_7080

R_7080

Stock

BarCodeFlashcard

StockID

 

 

R_7081

R_7081

StockItem

BarCodeFlashcard

StockItemID

 

 

R_7083

R_7083

Package

BarCodeFlashcard

PackageID

 

 

R_7084

R_7084

BarCodeFlashcard

BarCodeFile

BarCodeFlashcardID

 

 

R_8160

R_8160

StockLimitType

StockLimitTypeText

StockLimitTypeID

 

 

R_8161

R_8161

StockLimitType

StockCostLimit

StockLimitTypeID

 

 

R_8163

R_8163

Stock

StockCostLimit

StockID

 

 

R_8164

R_8164

StockCostLimit

StockCostLimitUsed

StockCostLimitID

 

 

R_8165

R_8165

Episode

StockCostLimitUsed

EpisodeID

 

 

R_8166

R_8166

Event

StockCostLimitUsed

EventID

 

 

R_8167

R_8167

StockCostLimitUsed

LSIQStockCostLimitUsed

StockCostLimitUsedID

 

 

R_8168

R_8168

StockItemQuantity

LSIQStockCostLimitUsed

StockItemQuantityID

 

 

R_8173

R_8173

Stock

StockItemQuota

StockID

 

 

R_8174

R_8174

StockItem

StockItemQuota

StockItemID

 

 

R_8175

R_8175

Package

StockItemQuota

PackageID

 

 

R_8280

R_8280

BloodDetails

StockItemQuantityIndex

BloodDetailsID

 

 

R_8281

R_8281

BloodDetails

StockItemQuantity

BloodDetailsID

 

 

R_8282

R_8282

ResourceItem

BloodDetails

ResourceID

 

 

R_8283

R_8283

DictionaryValue

BloodDetails

DictionaryValueID

 

 

R_8284

R_8284

DictionaryValue

BloodDetails

Dic_DictionaryValueID

 

 

R_8285

R_8285

DictionaryValue

BloodDetails

Dic_DictionaryValueID2

 

 

R_8411

R_8411

PerfService

BloodCrossmatch

PerfServiceID

 

 

R_8412

R_8412

StockItem

BloodCrossmatch

StockItemID

 

 

R_8413

R_8413

BloodDetails

BloodCrossmatch

BloodDetailsID

 

 

R_8414

R_8414

SeriesData

BloodCrossmatch

SeriesDataID

 

 

R_8490

R_8490

StockItemQuantity

SIQExtra

StockItemQuantityID

 

 


1  2  3